Çѱ¹Á¤º¸Åë½ÅÇÐȸ ³í¹®Áö (Journal of the Korea Institute of Information and Communication Engineering)
Current Result Document :
ÇѱÛÁ¦¸ñ(Korean Title) |
SQLite3 ¸ð¹ÙÀÏ µ¥ÀÌÅͺ£À̽ºÀÇ °»½Å ¼º´É ºñ±³ |
¿µ¹®Á¦¸ñ(English Title) |
Modification Performance Comparison of SQLite3 Mobile Databases |
ÀúÀÚ(Author) |
ÃÖÁø¿À
Jin-oh Choi
|
¿ø¹®¼ö·Ïó(Citation) |
VOL 22 NO. 12 PP. 1571 ~ 1576 (2018. 12) |
Çѱ۳»¿ë (Korean Abstract) |
ÃÖ±Ù ¸ð¹ÙÀÏ µð¹ÙÀ̽ºÀÇ °¡Àå ÁÖ¸ñ¹Þ´Â º¯È´Â °è»ê ¼º´ÉÀÇ È¹±âÀûÀÎ Çâ»ó, ÀúÀå ¿ë·®ÀÇ ´ëÆøÀûÀÎ Áõ°¡, ÀÎÅͳÝÀÇ »ó½Ã ¿¬°á, ±×¸®°í µð½ºÇ÷¹ÀÌ ±â¼úÀÇ Á¤±³ÇÑ ¹ßÀüÀ¸·Î ²ÅÀ» ¼ö ÀÖ´Ù. ÀÌ¿¡ µû¶ó, ¸ð¹ÙÀÏ µð¹ÙÀ̽º¸¦ È°¿ëÇÑ µ¥ÀÌÅͺ£À̽º ÀÀ¿ëÀÌ »õ·Ó°Ô µîÀåÇÏ°í ÀÖ´Ù. ÀÌ·¯ÇÑ ÀÀ¿ë¿¡´Â ¸ð¹ÙÀÏ ¼¹ö¿ë µ¥ÀÌÅͺ£À̽º, ¿¡Áö ÄÄÇ»ÆÃÀ» À§ÇÑ µ¥ÀÌÅͺ£À̽º, Æ÷±× ÄÄÇ»Æà µîÀÌ ÀÖ´Ù. µû¶ó¼ ÇöÀç Ãâ½ÃµÈ ¸ð¹ÙÀÏ µ¥ÀÌÅͺ£À̽º¿¡ ÁÖ¸ñÇÏ°í ±×·¯ÇÑ ÀÀ¿ëµé¿¡ ÀûÇÕÇÑ ¼º´ÉÀ» °¡Áö°í ÀÖ´ÂÁö ÁÖ¸ñÇÏ´Â °ÍÀÌ Áß¿äÇÏ´Ù. ÀÌ ³í¹®¿¡¼´Â ´ëÇ¥ÀûÀÌ°í ¿ì¼öÇÑ ¸ð¹ÙÀÏ µ¥ÀÌÅͺ£À̽ºÀÎ SQLite3¸¦ ¼±ÅÃÇÏ¿© °»½Å ¼º´É ¹× Ư¼ºÀ» Å×½ºÆ®Çϱâ À§ÇÑ ½ÇÇèÀ» ½Ç½ÃÇÑ´Ù. ½ÇÇè °á°ú¸¦ Æò°¡Çϱâ À§ÇÏ¿© µ¿ÀÏÇÑ È¯°æ¿¡¼ Oracle µ¥ÀÌÅͺ£À̽ºÀÇ °á°ú¿Í ºñ±³ÇÏ¿´´Ù. ½ÇÇè °á°ú SQLite3ÀÇ Insert ¼º´ÉÀº °³¼± ¿©Áö°¡ ¸¹¾ÒÀ¸¸ç, Update ¼º´ÉÀº ¾ÆÁÖ ¿ì¼öÇÑ °ÍÀ¸·Î ¹àÇôÁ³´Ù. ƯÈ÷ Range Query¿¡ ¿ì¼öÇÑ ¼º´ÉÀ» º¸¿´´Ù.
|
¿µ¹®³»¿ë (English Abstract) |
Recently, the attractive changes of mobile device are a improvement of the computing performance, dramatic improvement of storage capacity, constant connection to the internet, and sophisticated development of display technology. As a result, database applications utilizing mobile devices are emerging. These applications include databases for mobile servers, databases for edge computing, and fog computing. Therefore, it is important to pay attention to the current mobile database and pay attention to whether it has suitable performance for the applications. In this paper, the most common mobile database, SQLite3 is selected and experimented to test and understand the update performance and characteristics. The results of experiment are compared with the one of Oracle database at the same condition to evaluate the experiment. As a result, Insert Performance of SQLite3 has a lot of points to be improved and Update performance is very good. Especially, the performance of Range Query is excellent.
|
Å°¿öµå(Keyword) |
SQLite3
°»½Å ¼º´É
¸ð¹ÙÀÏ µ¥ÀÌÅͺ£À̽º
¿À¶óŬ Å×½ºÆ®
Mobile Database
Oracle Test
SQLite3
Update Performance
|
ÆÄÀÏ÷ºÎ |
PDF ´Ù¿î·Îµå
|